

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN"
  "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">

<html xmlns="http://www.w3.org/1999/xhtml">
  <head>
    <meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
    
    <title>Move File to Database &mdash; Red-R v1 documentation</title>
    <link rel="stylesheet" href="../_static/default.css" type="text/css" />
    <link rel="stylesheet" href="../_static/pygments.css" type="text/css" />
    <script type="text/javascript">
      var DOCUMENTATION_OPTIONS = {
        URL_ROOT:    '../',
        VERSION:     '1',
        COLLAPSE_INDEX: false,
        FILE_SUFFIX: '.html',
        HAS_SOURCE:  true
      };
    </script>
    <script type="text/javascript" src="../_static/jquery.js"></script>
    <script type="text/javascript" src="../_static/underscore.js"></script>
    <script type="text/javascript" src="../_static/doctools.js"></script>
    <link rel="top" title="Red-R v1 documentation" href="../index.html" /> 
  </head>
  <body>
    <div class="related">
      <h3>Navigation</h3>
      <ul>
        <li class="right" style="margin-right: 10px">
          <a href="../genindex.html" title="General Index"
             accesskey="I">index</a></li>
        <li class="right" >
          <a href="../py-modindex.html" title="Python Module Index"
             >modules</a> |</li>
        <li><a href="../index.html">Red-R v1 documentation</a> &raquo;</li> 
      </ul>
    </div>  

    <div class="document">
      <div class="documentwrapper">
        <div class="bodywrapper">
          <div class="body">
            
  <div class="section" id="move-file-to-database">
<h1>Move File to Database<a class="headerlink" href="#move-file-to-database" title="Permalink to this headline">¶</a></h1>
<div class="section" id="authors">
<h2>Authors<a class="headerlink" href="#authors" title="Permalink to this headline">¶</a></h2>
<p>Kyle R. Covington, <a class="reference external" href="mailto:kyle&#37;&#52;&#48;red-r&#46;org">kyle<span>&#64;</span>red-r<span>&#46;</span>org</a></p>
</div>
<div class="section" id="documentation">
<h2>Documentation<a class="headerlink" href="#documentation" title="Permalink to this headline">¶</a></h2>
<p>Reads files from a text file and brings them into RedR in the form of an SQLite structure.  These files should be like a table and should have values that are separated either by a tab, space, or comma.  You can use the scan feature to scan a small part of your data and make sure that it is in the correct format.  You can also set a column to represent the row names of your data.  This is encouraged if you have row names as some widgets rely on row names to help them function.  By specifying a column as a rownames column that column will have the reserved word of Rownames no matter what the column name is in the data table that you are reading.  SQLite tables can be connected to any RDataFrame or RList accepting widget.</p>
</div>
<div class="section" id="interface">
<h2>Interface<a class="headerlink" href="#interface" title="Permalink to this headline">¶</a></h2>
<div class="section" id="table-name">
<h3>Table Name<a class="headerlink" href="#table-name" title="Permalink to this headline">¶</a></h3>
<div class="section" id="description">
<h4>Description<a class="headerlink" href="#description" title="Permalink to this headline">¶</a></h4>
<p>No description entered for this GUI parameter</p>
<p>Class: base.lineEdit</p>
</div>
</div>
<div class="section" id="column-seperator">
<h3>Column Seperator<a class="headerlink" href="#column-seperator" title="Permalink to this headline">¶</a></h3>
<div class="section" id="id1">
<h4>Description<a class="headerlink" href="#id1" title="Permalink to this headline">¶</a></h4>
<p>No description entered for this GUI parameter</p>
<p>Class: base.radioButtons</p>
</div>
</div>
<div class="section" id="row-and-column-names">
<h3>Row and Column Names<a class="headerlink" href="#row-and-column-names" title="Permalink to this headline">¶</a></h3>
<div class="section" id="id2">
<h4>Description<a class="headerlink" href="#id2" title="Permalink to this headline">¶</a></h4>
<p>No description entered for this GUI parameter</p>
<p>Class: base.groupBox</p>
</div>
</div>
<div class="section" id="header">
<h3>Header<a class="headerlink" href="#header" title="Permalink to this headline">¶</a></h3>
<div class="section" id="id3">
<h4>Description<a class="headerlink" href="#id3" title="Permalink to this headline">¶</a></h4>
<p>No description entered for this GUI parameter</p>
<p>Class: base.checkBox</p>
</div>
</div>
<div class="section" id="decimal">
<h3>Decimal:<a class="headerlink" href="#decimal" title="Permalink to this headline">¶</a></h3>
<div class="section" id="id4">
<h4>Description<a class="headerlink" href="#id4" title="Permalink to this headline">¶</a></h4>
<p>No description entered for this GUI parameter</p>
<p>Class: base.lineEdit</p>
</div>
</div>
<div class="section" id="lines-to-scan">
<h3># Lines to Scan:<a class="headerlink" href="#lines-to-scan" title="Permalink to this headline">¶</a></h3>
<div class="section" id="id5">
<h4>Description<a class="headerlink" href="#id5" title="Permalink to this headline">¶</a></h4>
<p>No description entered for this GUI parameter</p>
<p>Class: base.lineEdit</p>
</div>
</div>
</div>
<div class="section" id="signals">
<h2>Signals<a class="headerlink" href="#signals" title="Permalink to this headline">¶</a></h2>
</div>
<div class="section" id="r-packages">
<h2>R Packages<a class="headerlink" href="#r-packages" title="Permalink to this headline">¶</a></h2>
<p>RSQLite</p>
</div>
</div>


          </div>
        </div>
      </div>
      <div class="sphinxsidebar">
        <div class="sphinxsidebarwrapper">
  <h3><a href="../index.html">Table Of Contents</a></h3>
  <ul>
<li><a class="reference internal" href="#">Move File to Database</a><ul>
<li><a class="reference internal" href="#authors">Authors</a></li>
<li><a class="reference internal" href="#documentation">Documentation</a></li>
<li><a class="reference internal" href="#interface">Interface</a><ul>
<li><a class="reference internal" href="#table-name">Table Name</a><ul>
<li><a class="reference internal" href="#description">Description</a></li>
</ul>
</li>
<li><a class="reference internal" href="#column-seperator">Column Seperator</a><ul>
<li><a class="reference internal" href="#id1">Description</a></li>
</ul>
</li>
<li><a class="reference internal" href="#row-and-column-names">Row and Column Names</a><ul>
<li><a class="reference internal" href="#id2">Description</a></li>
</ul>
</li>
<li><a class="reference internal" href="#header">Header</a><ul>
<li><a class="reference internal" href="#id3">Description</a></li>
</ul>
</li>
<li><a class="reference internal" href="#decimal">Decimal:</a><ul>
<li><a class="reference internal" href="#id4">Description</a></li>
</ul>
</li>
<li><a class="reference internal" href="#lines-to-scan"># Lines to Scan:</a><ul>
<li><a class="reference internal" href="#id5">Description</a></li>
</ul>
</li>
</ul>
</li>
<li><a class="reference internal" href="#signals">Signals</a></li>
<li><a class="reference internal" href="#r-packages">R Packages</a></li>
</ul>
</li>
</ul>

  <h3>This Page</h3>
  <ul class="this-page-menu">
    <li><a href="../_sources/widgets/readSQLiteFile.txt"
           rel="nofollow">Show Source</a></li>
  </ul>
<div id="searchbox" style="display: none">
  <h3>Quick search</h3>
    <form class="search" action="../search.html" method="get">
      <input type="text" name="q" size="18" />
      <input type="submit" value="Go" />
      <input type="hidden" name="check_keywords" value="yes" />
      <input type="hidden" name="area" value="default" />
    </form>
    <p class="searchtip" style="font-size: 90%">
    Enter search terms or a module, class or function name.
    </p>
</div>
<script type="text/javascript">$('#searchbox').show(0);</script>
        </div>
      </div>
      <div class="clearer"></div>
    </div>
    <div class="related">
      <h3>Navigation</h3>
      <ul>
        <li class="right" style="margin-right: 10px">
          <a href="../genindex.html" title="General Index"
             >index</a></li>
        <li class="right" >
          <a href="../py-modindex.html" title="Python Module Index"
             >modules</a> |</li>
        <li><a href="../index.html">Red-R v1 documentation</a> &raquo;</li> 
      </ul>
    </div>
    <div class="footer">
        &copy; Copyright 2011, Anup Parikh, Kyle Covington.
      Created using <a href="http://sphinx.pocoo.org/">Sphinx</a> 1.0.7.
    </div>
  </body>
</html>